 namespace :db do  
   namespace :fixtures do  
   
		#desc 'Create YAML test fixtures from data in an existing database. 
		# Defaults to development database. Set RAILS_ENV to override.'  
     task :dump_all => :environment do  
       sql = "SELECT * FROM %s"  
       skip_tables = ["schema_info"]  
       ActiveRecord::Base.establish_connection(:production)  
       (ActiveRecord::Base.connection.tables - skip_tables).each do |table_name|  
         i = "000"  
         File.open("#{RAILS_ROOT}/test/fixtures/#{table_name}.yml", 'w') do |file|  
           data = ActiveRecord::Base.connection.select_all(sql % table_name)  
           file.write data.inject({}) { |hash, record|  
             hash["#{table_name}_#{i.succ!}"] = record  
             hash  
           }.to_yaml
         end  
       end  
     end  
   end
end  
